// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_PROD_PLAN_APPLICATION
// * CreateDate    : 2011-8-11 20:46:48
// * Creater       : CodeSmith
// * LastChangeDate: 2011-8-11 20:46:48
// * LastChanger   : 2011-8-11 20:46:48
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
  	[Serializable]
    public partial class ProdPlanApplicationTable : TableInfo
    {
		public const string C_TableName = "PROD_PLAN_APPLICATION";
		
		public const string C_APPLICATION_ID = "APPLICATION_ID";
		public const string C_APPLICATION_CODE = "APPLICATION_CODE";
		public const string C_ORDER_ID = "ORDER_ID";
		public const string C_MAINTAIN_ORDER_ID = "MAINTAIN_ORDER_ID";
		public const string C_CUSTOMER_ID = "CUSTOMER_ID";
		public const string C_DEPARTMENT_ID = "DEPARTMENT_ID";
		public const string C_APPLICATION_PERSON = "APPLICATION_PERSON";
		public const string C_PAYMENT_TYPE = "PAYMENT_TYPE";
		public const string C_DELIVERY_DATE = "DELIVERY_DATE";
		public const string C_DELIVERY_PLACE = "DELIVERY_PLACE";
		public const string C_DELIVERY_PLACE_ZIPCODE = "DELIVERY_PLACE_ZIPCODE";
		public const string C_TRASPORT_TYPE = "TRASPORT_TYPE";
		public const string C_RECEIVED_PERSON = "RECEIVED_PERSON";
		public const string C_RECEIVED_PHONE = "RECEIVED_PHONE";
		public const string C_APPLICATION_TYPE = "APPLICATION_TYPE";
		public const string C_PRODUCT_TYPE_ID = "PRODUCT_TYPE_ID";
		public const string C_DELIVERY_TYPE = "DELIVERY_TYPE";
		public const string C_TOTAL_AMOUNT = "TOTAL_AMOUNT";
		public const string C_CREATED_DATE = "CREATED_DATE";
		public const string C_CREATED_BY = "CREATED_BY";
		public const string C_LAST_MODIFIED_DATE = "LAST_MODIFIED_DATE";
		public const string C_LAST_MODIFIED_BY = "LAST_MODIFIED_BY";
		public const string C_APPROVED_DATE = "APPROVED_DATE";
		public const string C_APPROVED_BY = "APPROVED_BY";
		public const string C_STATUS = "STATUS";
		public const string C_REMARK = "REMARK";
		
		public ProdPlanApplicationTable()
        {
            _tableName = "PROD_PLAN_APPLICATION";
        }
		
		protected static ProdPlanApplicationTable _current;
        public static ProdPlanApplicationTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }
		
		private static void Initial()
        {
            _current = new ProdPlanApplicationTable();

            _current.Add(C_APPLICATION_ID, new ColumnInfo(C_APPLICATION_ID,"ApplicationId", true, typeof(string)));
            _current.Add(C_APPLICATION_CODE, new ColumnInfo(C_APPLICATION_CODE,"ApplicationCode", false, typeof(string)));
            _current.Add(C_ORDER_ID, new ColumnInfo(C_ORDER_ID,"OrderId", false, typeof(string)));
            _current.Add(C_MAINTAIN_ORDER_ID, new ColumnInfo(C_MAINTAIN_ORDER_ID,"MaintainOrderId", false, typeof(string)));
            _current.Add(C_CUSTOMER_ID, new ColumnInfo(C_CUSTOMER_ID,"CustomerId", false, typeof(string)));
            _current.Add(C_DEPARTMENT_ID, new ColumnInfo(C_DEPARTMENT_ID,"DepartmentId", false, typeof(string)));
            _current.Add(C_APPLICATION_PERSON, new ColumnInfo(C_APPLICATION_PERSON,"ApplicationPerson", false, typeof(string)));
            _current.Add(C_PAYMENT_TYPE, new ColumnInfo(C_PAYMENT_TYPE,"PaymentType", false, typeof(string)));
            _current.Add(C_DELIVERY_DATE, new ColumnInfo(C_DELIVERY_DATE,"DeliveryDate", false, typeof(DateTime)));
            _current.Add(C_DELIVERY_PLACE, new ColumnInfo(C_DELIVERY_PLACE,"DeliveryPlace", false, typeof(string)));
            _current.Add(C_DELIVERY_PLACE_ZIPCODE, new ColumnInfo(C_DELIVERY_PLACE_ZIPCODE,"DeliveryPlaceZipcode", false, typeof(string)));
            _current.Add(C_TRASPORT_TYPE, new ColumnInfo(C_TRASPORT_TYPE,"TrasportType", false, typeof(string)));
            _current.Add(C_RECEIVED_PERSON, new ColumnInfo(C_RECEIVED_PERSON,"ReceivedPerson", false, typeof(string)));
            _current.Add(C_RECEIVED_PHONE, new ColumnInfo(C_RECEIVED_PHONE,"ReceivedPhone", false, typeof(string)));
            _current.Add(C_APPLICATION_TYPE, new ColumnInfo(C_APPLICATION_TYPE,"ApplicationType", false, typeof(string)));
            _current.Add(C_PRODUCT_TYPE_ID, new ColumnInfo(C_PRODUCT_TYPE_ID,"ProductTypeId", false, typeof(string)));
            _current.Add(C_DELIVERY_TYPE, new ColumnInfo(C_DELIVERY_TYPE,"DeliveryType", false, typeof(string)));
            _current.Add(C_TOTAL_AMOUNT, new ColumnInfo(C_TOTAL_AMOUNT,"TotalAmount", false, typeof(decimal)));
            _current.Add(C_CREATED_DATE, new ColumnInfo(C_CREATED_DATE,"CreatedDate", false, typeof(DateTime)));
            _current.Add(C_CREATED_BY, new ColumnInfo(C_CREATED_BY,"CreatedBy", false, typeof(string)));
            _current.Add(C_LAST_MODIFIED_DATE, new ColumnInfo(C_LAST_MODIFIED_DATE,"LastModifiedDate", false, typeof(DateTime)));
            _current.Add(C_LAST_MODIFIED_BY, new ColumnInfo(C_LAST_MODIFIED_BY,"LastModifiedBy", false, typeof(string)));
            _current.Add(C_APPROVED_DATE, new ColumnInfo(C_APPROVED_DATE,"ApprovedDate", false, typeof(DateTime)));
            _current.Add(C_APPROVED_BY, new ColumnInfo(C_APPROVED_BY,"ApprovedBy", false, typeof(string)));
            _current.Add(C_STATUS, new ColumnInfo(C_STATUS,"Status", false, typeof(string)));
            _current.Add(C_REMARK, new ColumnInfo(C_REMARK,"Remark", false, typeof(string)));
			
		}
		
		public ColumnInfo APPLICATION_ID
        {
            get { return this[C_APPLICATION_ID]; }
        }
		
		public ColumnInfo APPLICATION_CODE
        {
            get { return this[C_APPLICATION_CODE]; }
        }
		
		public ColumnInfo ORDER_ID
        {
            get { return this[C_ORDER_ID]; }
        }
		
		public ColumnInfo MAINTAIN_ORDER_ID
        {
            get { return this[C_MAINTAIN_ORDER_ID]; }
        }
		
		public ColumnInfo CUSTOMER_ID
        {
            get { return this[C_CUSTOMER_ID]; }
        }
		
		public ColumnInfo DEPARTMENT_ID
        {
            get { return this[C_DEPARTMENT_ID]; }
        }
		
		public ColumnInfo APPLICATION_PERSON
        {
            get { return this[C_APPLICATION_PERSON]; }
        }
		
		public ColumnInfo PAYMENT_TYPE
        {
            get { return this[C_PAYMENT_TYPE]; }
        }
		
		public ColumnInfo DELIVERY_DATE
        {
            get { return this[C_DELIVERY_DATE]; }
        }
		
		public ColumnInfo DELIVERY_PLACE
        {
            get { return this[C_DELIVERY_PLACE]; }
        }
		
		public ColumnInfo DELIVERY_PLACE_ZIPCODE
        {
            get { return this[C_DELIVERY_PLACE_ZIPCODE]; }
        }
		
		public ColumnInfo TRASPORT_TYPE
        {
            get { return this[C_TRASPORT_TYPE]; }
        }
		
		public ColumnInfo RECEIVED_PERSON
        {
            get { return this[C_RECEIVED_PERSON]; }
        }
		
		public ColumnInfo RECEIVED_PHONE
        {
            get { return this[C_RECEIVED_PHONE]; }
        }
		
		public ColumnInfo APPLICATION_TYPE
        {
            get { return this[C_APPLICATION_TYPE]; }
        }
		
		public ColumnInfo PRODUCT_TYPE_ID
        {
            get { return this[C_PRODUCT_TYPE_ID]; }
        }
		
		public ColumnInfo DELIVERY_TYPE
        {
            get { return this[C_DELIVERY_TYPE]; }
        }
		
		public ColumnInfo TOTAL_AMOUNT
        {
            get { return this[C_TOTAL_AMOUNT]; }
        }
		
		public ColumnInfo CREATED_DATE
        {
            get { return this[C_CREATED_DATE]; }
        }
		
		public ColumnInfo CREATED_BY
        {
            get { return this[C_CREATED_BY]; }
        }
		
		public ColumnInfo LAST_MODIFIED_DATE
        {
            get { return this[C_LAST_MODIFIED_DATE]; }
        }
		
		public ColumnInfo LAST_MODIFIED_BY
        {
            get { return this[C_LAST_MODIFIED_BY]; }
        }
		
		public ColumnInfo APPROVED_DATE
        {
            get { return this[C_APPROVED_DATE]; }
        }
		
		public ColumnInfo APPROVED_BY
        {
            get { return this[C_APPROVED_BY]; }
        }
		
		public ColumnInfo STATUS
        {
            get { return this[C_STATUS]; }
        }
		
		public ColumnInfo REMARK
        {
            get { return this[C_REMARK]; }
        }
		
		
		
	}
}

